Citibike Usage Throughout the Day; (Trip Starts by Hour)

g_allday_hour = ggplot(my_citibike_df, mapping = aes(hour))
g_weekday_hour = ggplot(weekday_df, mapping = aes(hour))
g_weekend_hour = ggplot(weekend_df, mapping = aes(hour))

g_allday_hour + geom_bar() + 
      xlab("Hour of the Day") + 
      ylab("Number of Trips Started") +
      ggtitle("Number of Citibike Trips Started Each Hour")

g_weekday_hour + geom_bar() + 
      xlab("Hour of the Day") + 
      ylab("Number of Trips Started") +
      ggtitle("Number of Citibike Trips Started Each Hour (WEEKDAYS)")

g_weekend_hour + geom_bar() + 
      xlab("Hour of the Day") + 
      ylab("Number of Trips Started") +
      ggtitle("Number of Citibike Trips Started Each Hour (WEEKENDS)")

Citibike Usage and Station Flow by Dock

#General Usage
maps_percent(0,23)
## Map from URL : http://maps.googleapis.com/maps/api/staticmap?center=New+York+City&zoom=12&size=640x640&scale=2&maptype=roadmap&language=en-EN&sensor=false
## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=New%20York%20City&sensor=false
## Source: local data frame [5 x 4]
## 
##      start.station.name     trips start.station.latitude
##                  (fctr)     (dbl)                  (dbl)
## 1 Pershing Square North 1.2530900               40.75187
## 2    Broadway & E 22 St 0.8707495               40.74034
## 3 West St & Chambers St 0.7719048               40.71755
## 4    E 17 St & Broadway 0.7668833               40.73705
## 5       W 21 St & 6 Ave 0.7466210               40.74174
## Variables not shown: start.station.longitude (dbl)
## [1] 0.1781759

maps_ratio(0, 23)
## Map from URL : http://maps.googleapis.com/maps/api/staticmap?center=New+York+City&zoom=12&size=640x640&scale=2&maptype=roadmap&language=en-EN&sensor=false
## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=New%20York%20City&sensor=false
## Source: local data frame [5 x 4]
## 
##            start.station.name trips_ratio start_trips end_trips
##                         (chr)       (dbl)       (int)     (int)
## 1          W 42 St & Dyer Ave    2.066334        4143      2005
## 2          Penn Station Valet    1.652757        6654      4026
## 3        Bedford Ave & S 9 St    1.510204         296       196
## 4 Lafayette Ave & St James Pl    1.501094         686       457
## 5     Monroe St & Classon Ave    1.445378         344       238
## [1] 0.9996697

Citibike Station Flow by Dock, Hours 6-10

maps_ratio(6, 10)
## Map from URL : http://maps.googleapis.com/maps/api/staticmap?center=New+York+City&zoom=12&size=640x640&scale=2&maptype=roadmap&language=en-EN&sensor=false
## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=New%20York%20City&sensor=false
## Source: local data frame [5 x 4]
## 
##        start.station.name trips_ratio start_trips end_trips
##                     (chr)       (dbl)       (int)     (int)
## 1      Penn Station Valet    22.91575        6256       273
## 2      W 42 St & Dyer Ave    19.85714        3197       161
## 3 Monroe St & Classon Ave    13.93333         209        15
## 4 Greene Ave & Throop Ave    13.50000         135        10
## 5      E 14 St & Avenue B    12.20295        3307       271
## [1] 1.116037

Citibike Station Flow by Dock, Hours 11-15

maps_ratio(11, 15)
## Map from URL : http://maps.googleapis.com/maps/api/staticmap?center=New+York+City&zoom=12&size=640x640&scale=2&maptype=roadmap&language=en-EN&sensor=false
## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=New%20York%20City&sensor=false
## Source: local data frame [5 x 4]
## 
##                start.station.name trips_ratio start_trips end_trips
##                             (chr)       (dbl)       (int)     (int)
## 1         Throop Ave & Myrtle Ave    3.833333          46        12
## 2 Pulaski St & Marcus Garvey Blvd    2.687500          43        16
## 3       Putnam Ave & Nostrand Ave    2.421053          46        19
## 4        Monroe St & Tompkins Ave    2.346154          61        26
## 5     Lafayette Ave & St James Pl    2.065789         157        76
## [1] 1.004107

Citibike Station Flow by Dock, Hours 16-20

maps_ratio(16, 20)
## Map from URL : http://maps.googleapis.com/maps/api/staticmap?center=New+York+City&zoom=12&size=640x640&scale=2&maptype=roadmap&language=en-EN&sensor=false
## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=New%20York%20City&sensor=false
## Source: local data frame [5 x 4]
## 
##        start.station.name trips_ratio start_trips end_trips
##                     (chr)       (dbl)       (int)     (int)
## 1         W 52 St & 5 Ave    7.751304        4457       575
## 2 E 53 St & Lexington Ave    5.109302        2197       430
## 3          47 Ave & 31 St    4.288889         193        45
## 4   India St & East River    3.734375         239        64
## 5      E 47 St & Park Ave    3.676103        4415      1201
## [1] 0.9320456

With more Time

Compare activity with Revenue. Subscriber vs single payer

Work out color scale

Analyze hour choices more carefully